Gestor 41T1Ak1KcqlrCDGA4njsr9XEjYzZTyLda1r9zPtM4AfHEsHNTUvTccNDbczqAC1O5Nb171hR+vXqbdH44SXnRsJeZQ1IQJKMfBWlaHT4LF7EWvkJ1UqapMBu6IXlKetj38j1AtML8rx5ey0c Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String cidade,System.String 30 False config Gestor select c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cid.nome as cidade from configuracao c left join cidade cid on cid.id = c.cidade_id pedido id,System.Int32 data_pedido,System.DateTime hora_pedido,System.String valor_bruto,System.Decimal valor_liquido,System.Decimal valor_entrega,System.Decimal nome_cliente,System.String logradouro,System.String logradouro_numero,System.String nome_bairro,System.String nome_cidade,System.String operador,System.String uf,System.String valor_produtos,System.Decimal telefone,System.String celular,System.String observacoes,System.String data_emissao,System.DateTime hora,System.String total_produtos,System.Decimal valor_desconto,System.Decimal numero_senha,System.Int32 30 False pedido Gestor SELECT p.id, p.data_emissao, p.hora, p.valor_bruto, p.valor_liquido, p.valor_entrega, p.nome_cliente, p.entrega_logradouro AS logradouro, p.entrega_numero AS logradouro_numero, c.nome AS nome_cidade, fun.nome_fantasia AS operador, p.entrega_uf AS uf, p.total_produtos, cli.telefone, cli.celular, COALESCE(p.entrega_bairro, bairro.nome) AS nome_bairro, p.observacoes, p.valor_desconto, p.numero_senha FROM orcamento p LEFT JOIN cidade c ON c.id = p.entrega_cidade_id LEFT JOIN correntista fun ON fun.id = p.vendedor_id LEFT JOIN correntista cli ON cli.id = p.cliente_id LEFT JOIN bairro ON bairro.id = cli.bairro_id WHERE p.id = {orcamento_id} pedido_item valor_unitario,System.Decimal quantidade,System.Decimal valor_desconto,System.Decimal valor_total,System.Decimal observacoes,System.String descricao,System.String valor_liquido,System.Decimal 30 False pedido_item Gestor SELECT i.valor_unitario, i.quantidade, i.valor_desconto, i.valor_liquido, i.observacoes, i.descricao FROM orcamento_item i WHERE i.orcamento_id = {orcamento_id} ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,orcamento_id,orcamento_id,System.Int32,_x0032_3014,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,14.8,21,0.8 Transparent 0,0.1,21,0.6 Arial,8 Center 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 15.4,29,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 25.2,5.2,1.4,0.4 Arial,9,Regular,Point,False,0 4c1f4d3caeed498abe9a2e46d38531f0 Right 0,0,0,0 Text17 Desc. Black Expression Transparent 25.2,6.4,1.4,0.4 Arial,8.25,Regular,Point,False,0 9dd898aab3b948f8818d2d7b2a4634c3 Right 0,0,0,0 Text23 {pedido_item.valor_desconto} Black , . 1 DataColumn Transparent 0,0.4,21,2 Transparent 0,0,21,0.6 Arial,9.75,Regular,Point,False,0 Center 0,0,0,0 Text4 {config.nome_fantasia} Black Expression Transparent 0,0.4,21,1.4 Arial,9,Regular,Point,False,0 Center 0,0,0,0 Text14 END.: {config.logradouro}, {config.numero} BAIRRO: {config.bairro} {config.cidade}/{config.uf} {config.telefone} Black Expression Transparent 0,1.8,21.2,0.8 Arial,11.25,Bold,Point,False,0 0868108067d44d658408840d5786bb3c Center 0,0,0,0 Text1 PEDIDO #{pedido.id} {IIF(pedido.numero_senha > 0, String.Concat("- SENHA: ", pedido.numero_senha.ToString()), "")} Black Expression ReportTitleBand1 Transparent 0,3.2,21,2.4 Transparent 0,0,1.2,0.4 Arial,9,Regular,Point,False,0 e57c5c99a5644cb19e9107c7e849bf76 0,0,0,0 Text2 Cliente: Black Expression Transparent 1.2,0,19.8,0.4 Arial,9.75,Bold,Point,False,0 6293a8c2077c40309577d99348ff4cec 0,0,0,0 Text5 {pedido.nome_cliente} Black Expression Transparent 0,0.4,1.2,0.4 Arial,9,Regular,Point,False,0 9ee9bfa133294ee18df923961182e8f5 0,0,0,0 Text6 End.: Black Expression Transparent True True 1.2,0.4,19.8,0.4 Arial,9.75,Bold,Point,False,0 7a77ce7bd13e4761a0106e4c9f1a927c 0,0,0,0 Text7 {pedido.logradouro}, Nº {pedido.logradouro_numero} Black ,,,,WordWrap=True,A=0 Expression Transparent 0,0.8,1.2,0.4 Arial,9,Regular,Point,False,0 1ca733eee6d64a3eb116e9b2b794d40e 0,0,0,0 Text10 Bairro: Black Expression Transparent 1.2,0.8,19.8,0.4 Arial,9.75,Bold,Point,False,0 10a0c2e10a5a44af8c91b96c1a295a41 0,0,0,0 Text11 {pedido.nome_bairro} Black DataColumn Transparent 0,1.2,1.2,0.4 Arial,9,Regular,Point,False,0 f3fa1b3c4c014b2b9451ead4483ad244 0,0,0,0 Text12 Cidade: Black Expression Transparent 1.2,1.2,19.8,0.4 Arial,9.75,Bold,Point,False,0 7ad223cefb994a6bbf577ca3a782ab76 0,0,0,0 Text13 {pedido.nome_cidade} - {pedido.uf} Black Expression Transparent 0,2,14.2,0.4 Arial,9,Regular,Point,False,0 d6384b8d5bc24394933167d7b20db38a 0,0,0,0 Text15 Descrição Black Expression Transparent 18,2,3,0.4 Arial,9,Regular,Point,False,0 61d2020d82624d708c806e23e4c906b9 Right 0,0,0,0 Text16 Vlr total Black Expression Transparent 16.2,2,1.8,0.4 Arial,9,Regular,Point,False,0 81ada9d3d36c41f2a3d833f1b450c428 Right 0,0,0,0 Text18 Qtde Black Expression Transparent 14.2,2,2,0.4 Arial,9,Regular,Point,False,0 2fd398d3d46740c99030c8d392e07199 Right 0,0,0,0 Text19 Vlr unit Black Expression Transparent 0,1.6,1.2,0.4 Arial,9,Regular,Point,False,0 998b20092e4f4504b09da7fc97008aee 0,0,0,0 Text32 Fone: Black Expression Transparent 1.2,1.6,19.8,0.4 Arial,9.75,Regular,Point,False,0 6233d75820e44c248c485d7fc50583ba 0,0,0,0 Text33 {pedido.telefone} - {pedido.celular} Black Expression pedido DataBand1 Transparent 0,6.4,21,0.4 Transparent True 0,0,14.2,0.4 Arial,8.25,Regular,Point,False,0 c0dd2d69e7c148448bfa4ab5a9b16e1a 0,0,0,0 txtDescricao {pedido_item.descricao} Black ,,,,WordWrap=True,A=0 Expression Transparent 18,0,3,0.4 Arial,8.25,Regular,Point,False,0 9f62e23982b34a9bbb13b9a5d161d3fe Right 0,0,0,0 Text22 {pedido_item.valor_liquido} Black , . 1 DataColumn Transparent 16.2,0,1.8,0.4 Arial,8.25,Regular,Point,False,0 aa2f38cb832a4bb296df96ce628592b8 Right 0,0,0,0 Text24 {pedido_item.quantidade} Black 0 , . 1 False False DataColumn Transparent 14.2,0,2,0.4 Arial,8.25,Regular,Point,False,0 26926710d2b949d7895bcb18f0f81c98 Right 0,0,0,0 Text25 {pedido_item.valor_unitario} Black , . 1 DataColumn 0,0,7.2,0.0254 Black Black b6001b2bd1d9401fa8a64cce59e97a31 HorizontalLinePrimitive2 Black 0,0.4,7.2,0.0254 Black Black 074281f988c84d0a9a230dc15b33de7d HorizontalLinePrimitive3 Black pedido_item DataBand2 Transparent 0,7.6,21,0.4 Transparent True 0,0,1.2,0.4 Arial,9,Regular,Point,False,0 589aff66e994492a83989ca0efc598a1 0,0,0,0 Text36 Obs.: Black Expression Transparent True 1.2,0,19.8,0.4 Arial,9,Regular,Point,False,0 3f27f30f8eba49b0b9999b8ee099c5e5 0,0,0,0 Text37 {pedido.observacoes} Black ,,,,WordWrap=True,A=0 Expression pedido DataBand3 Transparent 0,8.8,21,2.2 Transparent 0,0,2,0.4 Arial,9,Regular,Point,False,0 9097ac1704434d9cadf62b5ba1634254 0,0,0,0 Text26 Valor pedido: Black Expression Transparent 0,0.8,2,0.4 Arial,9,Regular,Point,False,0 f6861bcac79e4391b27be5282a2c491c 0,0,0,0 Text27 Entrega: Black Expression Transparent 2,0,19,0.4 Arial,9,Regular,Point,False,0 2fe4776967e34332a8888de6b2e96b26 0,0,0,0 Text29 {pedido.valor_produtos} Black , . 9 2 R$ Expression Transparent 2,0.8,19,0.4 Arial,9,Regular,Point,False,0 d50975115f154b1eaf398b260da3dd72 0,0,0,0 Text30 {pedido.valor_entrega} Black , . 9 2 R$ Expression Transparent 0,1.2,2,0.4 Arial,9,Regular,Point,False,0 d863b409385c4b0e888d6ad302c7d4f7 0,0,0,0 Text34 Data/hora: Black Expression Transparent 2,1.2,19,0.4 Arial,9,Regular,Point,False,0 c41f84adca6648bd9adf1d62fffdd4a5 0,0,0,0 Text35 {Format("{0:dd/MM/yyyy}", pedido.data_pedido)} {pedido.hora_pedido} Black Expression Transparent 0,0.4,2,0.4 Arial,9,Regular,Point,False,0 6c928950609544efa9e27dca1aa65bcc 0,0,0,0 Text8 Desconto: Black Expression Transparent 2,0.4,19,0.4 Arial,9,Regular,Point,False,0 69c99acd462f43b886c1ebed72c5764f 0,0,0,0 Text9 {pedido.valor_desconto} Black , . 9 2 R$ DataColumn Transparent 0,1.6,10.2,0.6 Arial,14.25,Regular,Point,False,0 5bbd20bb334d4f38844e936e9a7dd24e Right 0,0,0,0 Text31 Total: {Format("{0:C2}", pedido.valor_liquido)} Black Expression ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 0,0,0,0 Page1 13 21 True Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 3/7/2019 10:52:11 AM 9/25/2015 9:37:43 PM 7ba9bd6ff8e4440785c6d883a48ab0d4 Report Centimeters 2015.1.0 CSharp